﻿



-- 卡信息计数
create procedure [dbo].[Cainfo_Count_Get]
as
select total,cntyx,cntwx from
(select count(1) total from Ca_Info) aa left join
(select count(1) cntyx from Ca_Info where sfyx=1) bb on(1=1) left join
(select count(1) cntwx from Ca_Info where sfyx=0) cc on(1=1)